#include "sqlite.hpp"
#include <cassert>

int main()
{
    SqliteHelper helper("./test.db");
    assert(helper.open());

    const char* ct="create table if not exists student(sn int primary key ,name varchar(32),age int);";
    assert(helper.exec(ct,nullptr,nullptr));

    //const char* insert_Sql = "insert into student values(1,'小明',18),(2,'小黑',19),(3,'小红',18);";
    //assert(helper.exec(insert_Sql,nullptr,nullptr));

    const char* update_Sql = "update  student set name = '小虎' where sn = 2;";
    assert(helper.exec(update_Sql,nullptr,nullptr));

    helper.close();
    return 0;
}